<%@page import="java.sql.*,online.*,java.util.*,java.lang.*"%>
<jsp:useBean id="dab" class="online.DataAccesBean" scope="session"/>

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Fee Payment Master Details</title>
</head>

<body>
<%! 
       Connection con=null;
	   Statement st=null;
	   ResultSet rs=null;
	   int id=0,i=0,j=0;
	   String ss="10";
	   %>

<form method="POST" action="./FeePaymentMasterDetails1">

  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <table border="1" width="100%">
    <tr>
      <td width="100%" colspan="2">
        <p align="center">Fee Payment Master Details</td>
    </tr>
    <tr>
      <td width="50%">Fee Payment Type ID</td>
      <td width="50%"><input type="text" name="fptid" size="20"><font color=red>*Fee1001</font></td>
    </tr>
    <tr>
      <td width="50%">Fee Amount</td>
      <td width="50%"><input type="text" name="famount" size="20"></td>
    </tr>
    <tr>
      <td width="50%">Fee Payment ID</td>
      <td width="50%"><select size="1" name="fpid">
			  <%
		Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@server:1521:server","edu","edu");
 st=con.createStatement();
 rs=st.executeQuery("select * from fee_payment_master");
		System.out.println(rs);		
		while(rs.next())			
		{
	%>
	  <option><%=rs.getString(1)%></option>	
	<%
		}
	%>
        </select></td>
    </tr>
    <tr>
      <td width="100%" colspan="2">
        <p align="center">
		<input type="Submit" value="Insert" name="action">
		<input type="Submit" value="Delete" name="action">
		<input type="Submit" value="Search" name="action"></td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</form>
<%con.close();%>
</body>

</html>
